CSV validation
The CSV validation checks applies to all three import methods (Manual, API and IPSIS):
- Files will not process if any validation error is detected.
- Only required columns must be present in CSV file. Any missing required column will fail validation. Any other missing column is ignored.
- Only select users need to be in the CSV file (i.e. doesn’t require all users). Only listed users are processed.
- Any empty cell will be processed as a deletion of that attribute value for the user.
- Invalid column not in schema will fail validation.
- Invalid CSV (i.e. un-escaped string values) will fail validation.
- The system looks up each “user” datatype (username, manager) in Brightspace Learning Environment and any invalid match will fail validation.
- Any value not in range defined by schema will fail validation.
- String checks string length.
- Date checks date range.
- CSV file size must be less than 1GB.
- The d2l.Tools.ManagerRole.CoursesAvailableToAssign configuration variable must be set correctly for the Affiliated Org Units reserved attribute to process.